USE [AMS]
GO

/****** Object:  StoredProcedure [dbo].[GetRequestorListFull]    Script Date: 02/02/2010 13:20:56 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		Johan Celis
-- Create date: 2 Feb 2010
-- Description:	
-- =============================================
CREATE PROCEDURE [dbo].[GetRequestorListFull]
AS
BEGIN
    SELECT Requestor.KlantID, Requestor.Naam, Requestor.Adres, Requestor.Adres2, Requestor.Postnr, Requestor.PostnrA,
		Requestor.Woonplaats, Requestor.Land
    FROM Requestor
    ORDER BY Requestor.Naam ASC
END

GO

